Introduction

This site was created with the intention of answering the following question:

How has the quality of education/opportunities in the past 30 years differed in different kinds of schools, as well as for different types of British Columbian students (i.e., Indigenous? Special needs?)?

Note that although this is just one question, it is a very complex one, and so naturally, a lot of data is required to answer it. Thus, this website uses open data from British Columbia–specifically, the 1992-2021 data on grade-to-grade transition published by British Columbia Education Analytics. To gather information regarding the districts, this site also uses information regarding each district’s office, also published by the British Columbia Education Analytics. By using the grade-to-grade transitions as a metric for the quality of education/opportunities, we can formulate a nuanced response to the question.

If you wish to see the Github repository for this site, you can find it here.

\[\\[0.2in]\]

Methods

Data Prep

Our data came in the form of 3 ‘.xlsx’ files containing information regarding BC grade-to-grade transitions on a provincial, district and school level, while the data regarding the location of the offices of each district was in the form of a ‘.csv’ file. The three ‘.xlsx’ files each contained information on different periods: one file contained information from 1992/93 to 2000/01, another contained information from 2000/01 to 2010/11, and our last one contained information from 2010/11 to 2020/21. There are many rows in each of the ‘.xlsx’ files (the first had 374654, the second had 541501, and the third had 536978), but it is also worth noting that the data was not tidy, as some rows recorded data on “all students” whilst other rows recorded data on “Indigenous students”, so each row should not be treated as its own observation. Then, we combined our data into one large data table, and removed entries in our table with missing data.

Procedure

Before doing anything meaningful, we should first do some exploratory data analysis. Based on the structure of the data, I felt as though it would be most appropriate to look at the situation from all three levels. We begin by making interactive figures to understand the situation from a provincial and district level. We will also perform model fitting on a school level. By mimicking the structure of our data, we can make the most out of it!

#WORK IN PROGRESS (A lot of the existing work is from the Midterm)

\[\\[0.2in]\]

Results

Prior to doing anything, let’s do some exploratory data analysis. You can see the plots and analysis that were made for the provincial, district and school levels in the corresponding tabs.

Exploratory Data Analysis

Provincial Level

Below is an interactive plot. The axis is fixed for ease of comparison, but you can always zoom in. We can observe various things by tweaking the settings of the plot. Below are just a few discoveries that I found.

  • In the Province-Total and All Students setting, we can see that overall, as time went by, the percentage of students that successfully transitioned to the next grade increased. This is the most prominent for students in grades 8-11. It is also worth noting that the percentage of students in grades 10/11 that successfully transition to the next grade are significant lower than the percentage of students in the lower grades that successfully transition.
  • Keeping the bottom dropdown as All Students but altering the top dropdown between BC Public School and BC Independent School, we can see that the rates of grade transitions for students of BC public schools are lower than that of BC independent schools, but the increase in the rate of successful grade transitions is significantly higher in public schools. Furthermore, private schools (i.e., independent schools) seem to have a much higher rate of transition, especially for grade levels 8 and above. This does make sense, as private schools are often times more expensive, and so the students attending them naturally live in my affluent families.
  • Keeping the top dropdown as Province-Total but altering the bottom dropdown between Indigenous and Non Indigenous, we can see that the rate of successful grade transitions is significantly lower in Indigenous students compared to their non-Indigenous counterparts. We can also see that the increase in the rates of grade transitions over the years is higher for Indigenous students compared to non-Indigenous students.
  • Keeping the top dropdown as Province-Total but altering the bottom dropdown between Non Special Needs and Special Needs, we can see that the rate of successful grade transitions is significantly lower in special needs students compared to students without special needs.

\[\\[0.1in]\]

Figure 1: An interactive graph depicting the percentage of students in BC of each grade level that successfully transition to the next grade between the years 1993 and 2020.

\[\\[0.1in]\]

District Level

Below are two interactive plots. Figure 2 displays the individual data for each of the districts, whilst Figure 3 consists of the summary of all the districts for each year. The dropdown menus for both plots allow you to select a specific grade and population. The axis is fixed for ease of comparison, but you can always zoom in (or hover your mouse to see more details). There are many interesting things you can find with the interactive plots. Below are just a few findings:

  • The percentage of students who transitioned to the next grade for Grade 11 fluctuates very dramatically. Playing with the interactive boxplot, one can see that the variation in the rate of transitions from grade 11 to 12 from 2015 to 2020 has been significantly reduced (when compared with the past years). The median of the rates has also increased over time. As such, these plots suggest that there is more equality (due to the decrease in variation) in terms of education/opportunities across the districts, and the education/opportunities offered is of a higher quality (as indicated by the higher median).
  • Playing with the settings of Figure 3, we can see that for most grades (particularly the higher grades, like grade 11) the median percentage of Indigenous students per district who transitioned is significantly lower than that of non-Indigenous students in 1993. This difference is much smaller in 2020, but the median percentage is still less. The same can be said about the variation: the interquartile range (IQR) for the Indigenous 11th graders in different districts was much larger than that of the non-Indigenous counterparts in 1993. In 2020, this different has indeed shrunk, but the IQR for the Indigenous children is still roughly twice that of their non-Indigenous counterparts. As such, we can certainly say that there’s an improvement in the quality of education/opportunities for both Indigenous children and non-Indigenous children, but more work needs to be done.
  • The relationship between students with special needs and those without (again, particularly for the higher grades) is very similar to what was seen between Indigenous and non-Indigenous children–the variation for both of the rates decreased over time, but the variation of the rates for the students with special needs was typically higher than the rate for students with special needs. The difference now is minimal though (at least when compared to the past). Likewise, the median rates for both increased over time (although there was a period of time in which the special needs rates were decreasing), but the non-special needs students had a higher median rate for a while now. That said, the difference in the median rate in 2020 was very small.

\[\\[0.1in]\]

Figure 2: An interactive graph depicting the percentage of high school BC students that successfully transition to the next grade between the years 1993 and 2020.

\[\\[0.1in]\]

Figure 3: An interactive boxplot depicting the percentage of high school BC students from each district that successfully transitioned to the next grade between the years 1993 and 2020.

\[\\[0.1in]\]

Figure 4: Heatmap displaying the trend in overall transition rates for all Grade 11 students for each district over the years. (It is very likely that I will delete or tweak this heatmap prior to the submission of my final project. I really want to add a dropdown to it so I can display data from all grades all at once.)

School Level

#WORK IN PROGRESS (Will use my work from the Midterm)

\[\\[0.1in]\]

Conclusions and Summary

#WORK IN PROGRESS